Next30Days, Next31To60Days, Next61To90Days, Next91To365Days

Basic and Crystal syntax.

Returns

None

Action

Specifies a range of Date values that includes all dates in the period specified starting from today (including today).

Examples

The following examples are applicable to Crystal syntax:

If {orders.ORDER DATE} in Next30Days Then

    {orders.ORDER AMOUNT}

Else

    0

Returns the Amount if the date falls anywhere in the next 30 days starting from today (including today). The following table identifies the first and last dates included in the date range if today equals 04/10/98.

If today = 04/10/98 {orders.ORDER DATE} {orders.ORDER AMOUNT}

not in range

04/09/98

0

first date included

04/10/98

1252.24


04/30/98

1597.87


05/05/98

2546.35

last date included

05/10/98

5462.21

If {orders.ORDER DATE} in Next31To60Days Then

    {orders.ORDER AMOUNT}

Else

    0

Returns the Amount if the date falls anywhere in the next 31 to 60 days starting from today. The following table identifies the first and last dates included in the date range if today equals 04/10/98.

If today = 04/10/98 {orders.ORDER DATE} {orders.ORDER AMOUNT}

not in range

05/10/98

0

first date included

05/11/98

1252.24


05/30/98

1597.87


06/03/98

2546.35

last date included

06/09/98

5462.21

Note:    If you would like to base the date range on a date other than today's date, you must either change the date via the Date/Time option in the Windows Control Panel, or change the report print date via the Set Print Date/Time command in the Report Menu.



Seagate Software IMG Holdings, Inc.
http://www.seagatesoftware.com
Support services:
http://support.seagatesoftware.com